--1ߡ
Delete from ReaderTable;
Insert into ReaderTable values('R120291',
'',
'myname1',
'123456',
'',
'ϴѧϢѧԺ',
'ѧ',
10,
'ڶо');
Insert into ReaderTable values('R120292',
'',
'myname2',
'123456',
'Ů',
'ϴѧϢѧԺ',
'ѧ',
7,
'ʦ');
Insert into ReaderTable values('R120293',
'ֱ',
'myname3',
'123456',
',
'ϴѧѧԺ',
'ѧ',
8,
'ڶо');
Insert into ReaderTable values('R120294',
'',
'myname4',
'123456',
'Ů',
'ϴѧϢѧԺ',
'ѧ',
9,
'ڶо');
Insert into ReaderTable values('R120295',
'̽',
'myname5',
'123456',
'Ů',
'ѧѧԺ',
'ѧ',
15,
'ʦ');
Insert into ReaderTable values('R120296',
'ӭ',
'myname6',
'123456',
'Ů',
'ѧѧԺ',
'ѧ',
0,
'');
Select * from ReaderTable;

-- 2顱 
Delete from BookTable;
Insert into BookTable values ('11230',
'C++ Builder 6ݿϵͳ̳',
'',
'̫',
'2005-5-3',
'TP312C-484',
48.0,
'');
Insert into BookTable values ('11231',
'Delphi 2005 ݿϵͳ̳',
'',
'',
'2006-3-3',
'TP312C++-20',
88.0,
'') ;
Insert into BookTable values ('11232',
'ݿϵͳ',
'Ȩ',
'ǳ',
'2004-12-3',
'TP506-90',
88.0,
'ڹ');
Insert into BookTable values ('11233',
'',
'޹',
'',
'1980-1-3',
'TP45-3',
45.0,
'ڹ');
Insert into BookTable values ('11234',
'ھ̳',
'ܲ',
'',
'2006-1-3',
'TP46-4',
32.0,
'') ;
Insert into BookTable values ('11235',
'㷨',
'',
'̫',
'2005-8-12',
'TP34-80',
18.0,
'');
Insert into BookTable values ('11236',
'־ս',
'',
'ǳ',
'2000-12-1',
'TP88-99',
78.0,
'');
Insert into BookTable values ('11237',
'Oracle 10g̳',
'ŷ',
'',
'2006-4-1',
'TP312C-008',
83.0,
'ڹ') ;
Select * from BookTable;

-- 3Ա
Delete from LibrarianTable;
Insert into LibrarianTable values ('L1260',  'ν', '654321') ;
Insert into LibrarianTable values ('L1261',  '', '123456') ;
Insert into LibrarianTable values ('L1262',  'ֳ', '123456') ;
Insert into LibrarianTable values ('L1263',  '', '123456') ;
Insert into LibrarianTable values ('L1264',  '־', '123456') ;
Select * from LibrarianTable;

-- 4ġݲ
Delete from BorrowingTable;
Insert into BorrowingTable(ReaderId,
ReaderName,
ISBN,
BookName,
Editor,
BorrowDate,
ReturnDate,
LibrarianId) values('R120291',
'',
'11230',
'C++ Builder 6ݿϵͳ̳',
'',
'2006-3-1',
'2006-4-1',
'L1261');
Insert into BorrowingTable(ReaderId,ReaderName,ISBN,BookName,Editor,BorrowDate,ReturnDate,
LibrarianId) values('R120293', 'ֱ', '11231',
'Delphi 2005 ݿϵͳ̳',  '', '2006-4-8',
'2006-5-8', 'L1261');
Insert into BorrowingTable(ReaderId,ReaderName,ISBN,BookName,Editor,BorrowDate,ReturnDate,
LibrarianId) values('R120292', '', '11232',  'ݿϵͳ',
'Ȩ', '2005-12-23', '2006-1-23', 'L1260');
Select * from BorrowingTable; 
